home *** CD-ROM | disk | FTP | other *** search
/ Gigarom 4 / Mac Giga-ROM 4.0 - 1993.toast / FILES / BUS / A-E / BASIC BILLING.sea / BASIC BILLING / Billing (.txt) next >
FileMaker Pro Database  |  1990-11-03  |  40KB  |  292 lines

  1. PLEASE PAY
  2. HBAM2001MAY84
  3. 123-4567
  4. 765-4321
  5. Apartments
  6. Bambi
  7. Crossing
  8. Drive
  9. Drive
  10. Deerfield
  11. Deerhaven
  12. 12345
  13. 54321
  14. Antler
  15. Cleaner
  16. Fur-so-soft
  17. Haunches
  18. Shampoo
  19. Company
  20. Address
  21. Address
  22. State
  23. Company
  24. Telephone
  25. 4.01I
  26. 11/3/90
  27.     ACCOUNTNO
  28.     ADDRESS 1
  29.     ADDRESS 2
  30. AMT PAID
  31. CITY STATE
  32.     COMPADDR1
  33.     COMPADDR2
  34. COMPCITYSTATEZIP
  35. COMPNAME
  36.     COMPPHONE
  37. CURRENT
  38. CURRENTSUM
  39. DESCRIPTION
  40. INVOICE DATE
  41. INVOICE NO
  42. NINETY
  43. $    NINETYSUM
  44. ONE_TWENTY
  45. ONE_TWENTYSUM
  46. PHONE
  47. PLEASE PAY
  48. QUANTITY
  49. REF DATE
  50. SIXTY
  51. SIXTYSUM
  52. STMT AMT PAID
  53. STMT PLEASE PAY
  54. STMT TAX DUE
  55. STMT TOTAL DUE
  56. STMT TOTALPLUSTAX
  57. TAXDUE
  58. TAXRATE
  59. THIRTY
  60. "    THIRTYSUM
  61. TOTAL
  62.     TOTAL DUE
  63. TOTALPLUSTAX
  64. PhoneB
  65. A    AccountNoB
  66.     Customers
  67. NameB
  68.     Customers
  69. A    Address 1B
  70.     Customers
  71. A    Address 2B
  72.     Customers
  73. City StateB
  74.     Customers
  75.     Customers
  76. Invoice NoB
  77. Invoice DateB
  78. DescriptionB
  79. QuantityB
  80. RateB
  81. TotalB
  82. round(Quantity * Rate,2)F
  83. Amt PaidB
  84. Please PayB
  85. TotalPlusTax- Amt PaidF
  86. A    Total DueB
  87. sum(Total)F
  88. TaxRateB
  89. Company Data
  90. TaxDueB
  91. round(TaxRate * Total Due,2)F
  92. TotalPlusTaxB
  93. Total Due + TaxDueF
  94. Stmt Total DueB
  95. Stmt Tax DueB
  96. Stmt TotalPlusTaxB
  97. Stmt Amt PaidB
  98. Stmt Please PayB
  99. CompNameB
  100. Company Data
  101. A    CompAddr1B
  102. Company Data
  103. A    CompAddr2B
  104. Company Data
  105. CompCityStateZipB
  106. Company Data
  107. A    CompPhoneB
  108. Company Data
  109. Ref DateB
  110. E:if(REF DATE - Invoice Date > 0, REF DATE - Invoice Date,0)F"
  111. CurrentB
  112. if(Age <30,Please Pay,0)F
  113. ThirtyB
  114. E&if(Age >=30 and Age < 60,Please Pay,0)
  115. SixtyB
  116. E)if(Age >= 60 and Age <= 90, Please Pay,0)F(
  117. NinetyB
  118. E)if(Age >= 90 and Age < 120, Please Pay,0)F(
  119. One_TwentyB
  120. if(Age >= 120, Please Pay, 0)F
  121. CurrentSumB
  122. 'A    ThirtySumB
  123. SixtySumB
  124. )A    NinetySumB
  125. One_TwentySumB
  126.     STATEMENT
  127. DATE: //
  128.  DATE
  129. NUMBER
  130. DESCRIPTION
  131.     PRICE EA.
  132. TOTAL
  133.     SUB TOTAL
  134.     TOTAL DUE
  135. PAYMENT
  136. BALANCE DUE
  137.     STATEMENT
  138. DATE: //
  139.  DATE
  140. NUMBER
  141. DESCRIPTION
  142.     PRICE EA.
  143. TOTAL
  144.     SUB TOTAL
  145.     TOTAL DUE
  146. PAYMENT
  147. BALANCE DUE
  148. INVOICE
  149. DATE:
  150. DESCRIPTION
  151.     PRICE EA.
  152. TOTAL
  153.     SUB TOTAL
  154.     TOTAL DUE
  155. PAYMENT
  156. BALANCE DUE
  157. INVOICE
  158. DATE:
  159. DESCRIPTION
  160.     PRICE EA.
  161. TOTAL
  162.     SUB TOTAL
  163.     TOTAL DUE
  164. PAYMENT
  165. BALANCE DUE
  166. DATE:
  167. SubTtl
  168.     Acct. No.
  169. Total
  170. Payment
  171. Balance
  172. DESCRIPTION
  173.     PRICE EA.
  174. TOTAL
  175. DATE:
  176. SubTtl
  177.     Acct. No.
  178. Total
  179. PLEASE PAY
  180. Payment
  181. Balance
  182. DESCRIPTION
  183.     PRICE EA.
  184. TOTAL
  185. AGING REPORT 
  186. Account
  187. Current
  188. 30 Days
  189. 60 Days
  190. 90 Days
  191. 120 Days
  192.     Total Due
  193. Totals
  194. Page ##
  195. AGING REPORT 
  196. Account
  197. Current
  198. 30 Days
  199. 60 Days
  200. 90 Days
  201. 120 Days
  202.     Total Due
  203. Totals
  204. Page ##
  205. Enter the aging date
  206. then press Command =
  207.  At the prompt, click on Replace.
  208. Enter the aging date
  209. then press Command =
  210.  At the prompt, click on Replace.
  211. 123-4567B
  212. John DoeD
  213. 123 Deer Crossing Drive.F
  214. Deerhaven, DEG
  215. 12345H
  216. 1/1/91J
  217. Antler Wax
  218. Hoof CleanerK
  219. 1.25M
  220. 6.25O
  221. 10.06P
  222. 8.75Q
  223. 1.31S
  224. 10.06Y
  225. Company Name Goes HereZ    Address 1[    Address 2\
  226. City State and Zip]
  227. Company Telephone^
  228. 1/31/91`
  229. 10.06c
  230. 765-4321B
  231. 2C    Jane BuckD
  232. No. 1 Bambi ApartmentsE
  233. 789 Fawn DriveF
  234. Deerfield, DEG
  235. 54321H
  236. 1/1/91J
  237. Fur-So-SoftK
  238. 11.50O
  239. 11.5Y
  240. Company Name Goes HereZ    Address 1[    Address 2\
  241. City State and Zip]
  242. Company Telephone^
  243. 1/31/91`
  244. 123-4567B
  245. John DoeD
  246. 123 Deer Crossing Drive.F
  247. Deerhaven, DEG
  248. 12345H
  249. 11/3/90J
  250. Head & Haunches ShampooK
  251. 2.75M
  252. 8.25N
  253. 9.49O
  254. 8.25Q
  255. 1.24S
  256. 9.49Y
  257. Company Name Goes Here
  258. Z    Address 1[    Address 2\
  259. City State and Zip]
  260. Company Telephone^
  261. Create Invoice
  262. sample
  263. Print Invoice
  264. sample
  265. Print Statements
  266. Age Accounts
  267. Print Aging Report
  268. 'bQa2
  269. 4.01F#
  270. 4.01I
  271. 11/3/90
  272.     ACCOUNTNO
  273.     ADDRESS 1
  274.     ADDRESS 2
  275. AMT PAID
  276. CITY STATE
  277.     COMPADDR1
  278.     COMPADDR2
  279. COMPCITYSTATEZIP
  280. COMPNAME
  281.     COMPPHONE
  282. CURRENT
  283. CURRENTSUM
  284. DESCRIPTION
  285. INVOICE DATE
  286. INVOICE NO
  287. NINETY
  288. $    NINETYSUM
  289. ONE_TWENTY
  290. ONE_TWENTYSUM
  291. PHONE
  292.